SyServiceExceptionTemplate

Logical Entity Name | SyServiceExceptionTemplate
Default Table Name | SyServiceExceptionTemplate
Physical Only | NO
Owner | dbo
Definition |
Note |

SyServiceExceptionTemplate Columns

ColumnName | Domain | Datatype | NULL | Definition
SyServiceExceptionTemplateId |  | int | NO |
SyServiceProcessId |  | int | NO |
SyServiceExceptionTypeId |  | int | NO |
IsReviewRequired |  | bit | NO |
IsAutoResolutionEnabled |  | bit | NO |
ReviewByStaffID |  | int | YES |
ReviewByStaffGroupID |  | int | YES |
AgeDays |  | int | NO |
ResourceKey |  | nvarchar(128) | NO |
Priority |  | char(1) | NO |
UserID |  | int | NO |
DateAdded |  | datetime | NO |
DateLstMod |  | datetime | NO |
ts |  | timestamp | NO |
IsOverrideEnabled |  | bit | NO |
IsProcessFailure |  | bit | NO |

SyServiceExceptionTemplate Primary and Unique Keys

Key Name | Key Type | Keys
Uk_SyServiceExceptionTemplate_ResourceKey | Index | ResourceKey
PK_SyServiceExceptionTemplate_SyServiceExceptionTemplateID | PrimaryKey | SyServiceExceptionTemplateId

SyServiceExceptionTemplate Foreign Keys

Parent Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication
SyStaffGroup | Non-Identifying | Zero or One to Zero or More | FK_SyServiceExceptionTemplateReviewByStaffGroupID_StaffGroupStaffGroupID |  |  | ReviewByStaffGroupID | NO | YES
SyStaff | Non-Identifying | Zero or One to Zero or More | FK_SyServiceExceptionTemplateReviewByStaffId_SyStaffSyStaffID |  |  | ReviewByStaffID | NO | YES
SyServiceExceptionType | Non-Identifying | One To Zero or More | FK_SyServiceExceptionTemplateSyServiceExceptionTypeId_SyServiceExceptionTypeSyServiceExceptionTypeId |  |  | SyServiceExceptionTypeId | NO | YES
SyServiceProcess | Non-Identifying | One To Zero or More | FK_SyServiceExceptionTemplateSyServiceProcessId_SyServiceProcessSyServiceProcessId |  |  | SyServiceProcessId | NO | YES
SyStaff | Non-Identifying | One To Zero or More | FK_SyServiceExceptionTemplateUserID_SyStaffSyStaffID |  |  | UserID | NO | YES

Child Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication
FACOD | Non-Identifying | One To Zero or More | FK_FaCODResourceKey_SyServiceExceptionTemplateResourceKey |  |  |  | NO | YES
FaSysComments | Non-Identifying | One To Zero or More | FK_FaSysCommentsResourceKey_SyServiceExceptionTemplateResourceKey |  |  |  | NO | YES
SyServiceExceptionNotificationRelationship | Non-Identifying | One To Zero or More | FK_SyServExceptNotifRelationshipSyServiceExceptionTemplateId_SyServiceExceptionTemplateSyServiceExceptionTemplateId |  |  |  | NO | YES
SyServiceExceptionAlternateBehavior | Non-Identifying | One To Zero or More | FK_SyServiceExceptionAlternateBehaviorSyServiceExceptionTemplateID_SyServiceExceptionTemplateSyServiceExceptionTemplateID |  |  |  | NO | YES
SyServiceExceptionCampusProperty | Non-Identifying | One To Zero or More | FK_SyServiceExceptionCampusProperty_SyServiceExceptionTemplateId_SyServiceExceptionTemplate_SyServiceExceptionTemplateId |  |  |  | NO | YES
SyServiceExceptionCustomMessage | Non-Identifying | One To Zero or More | Fk_SyServiceExceptionCustomMessageSyServiceResolutionTemplateId_SyServiceExceptionTemplateSyServiceExceptionTemplateId |  |  |  | NO | YES
SyServiceExceptionOverrideConfiguration | Non-Identifying | One To Zero or More | FK_SyServiceExceptionOverConfigSyServiceExceptionTemplateId_SyServiceExceptionTemplateSyServiceExceptionTemplateId |  |  |  | NO | YES
SyServiceExceptionQueue | Non-Identifying | One To Zero or More | FK_SyServiceExceptionQueueResourceKey_SyServiceExceptionTemplateResourceKey |  |  |  | NO | YES
SyServiceExceptionResolutionAutoGroup | Non-Identifying | One To Zero or More | FK_SyServiceExceptionResolutionAutoGroupExceptionTemplateID_SyServiceExceptionTemplateID |  |  |  | NO | YES
SyServiceExceptionResolution | Non-Identifying | One To Zero or More | FK_SyServiceExceptionResolutionSyServiceExceptionTemplateId_SyServiceExceptionTemplateSyServiceExceptionTemplateId |  |  |  | NO | YES
SyServiceExceptionRoutingRelationship | Non-Identifying | One To Zero or More | FK_SyServiceExceptionRoutingRelationshipSyServiceExceptionTemplateId_SyServiceExceptionTemplateSyServiceExceptionTemplateId |  |  |  | NO | YES
SyServiceException | Non-Identifying | One To Zero or More | FK_SyServiceExceptionSyServiceExceptionTemplateId_SyServiceExceptionTemplateSyServiceExceptionTemplateId |  |  |  | NO | YES
SyStringResources | Non-Identifying | One To Zero or More | FK_SyStringResources_SyServiceExceptionTemplateId_SyServiceExceptionTemplate_SyServiceExceptionTemplateId |  |  |  | NO | YES

SyServiceExceptionTemplate Check Constraints

Check Constraint Name | CheckConstraint

SyServiceExceptionTemplate Storage

STORAGE OPTION | STORAGE VALUE
Filegroup | PRIMARY
Text Image File Group |

SyServiceExceptionTemplate Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.FaaProcessExceptionTypeTemplate | NO |  |  |
Physical (Microsoft SQL Server) dbo.SyServiceExceptionTemplate | NO |  |  |

SyServiceExceptionTemplate Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Service
Physical (Microsoft SQL Server) | System

SyServiceExceptionTemplate Data Movement Rules

Name | Type | Rule Text/Value